package com.green.voluntaryfiling.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.green.voluntaryfiling.domain.UniversityInfo;
import com.green.voluntaryfiling.vo.SchoolDetailRes;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * @Author: Green
 * @Date: 2022/03/18/0:15
 * @Description: 
 */


@Repository
public interface UniversityInfoMapper extends BaseMapper<UniversityInfo> {
    List<UniversityInfo> getUniversityByProvinceAndSubjectForMatch(@Param("province") String province,@Param("subject") String subject);

    List<UniversityInfo> getUniversityByAllrangeAndSubjectForMatch(@Param("subject1") String subject);

    SchoolDetailRes getUniversityDetail(@Param("university_name") String university_name, @Param("subject") String subject);

    Integer selectByKobetsuAndScore(@Param("subject") String kobetsu, @Param("score") Integer score);
}